Introduction

FIFA!

The data that I will be using comes from FIFA, “Fédération Internationale de Football Association”, which translates to, International Federation of Association Football. This dataset collects data from 900 World Cup matches that was played in its history from Uruguay in 1930 to Russia in 2018. This data collected from GitHub.

What’s in the data? Can the next FIFA World Cup winner be predicted?

Which Countries have hosted the FIFA World Cup?

host
Uruguay
Italy
France
Brazil
Switzerland
Sweden
Chile
England
Mexico
Germany
Argentina
Spain
USA
Japan, South Korea
South Africa
Russia

When was the First Match from the data?

stage date home_team away_team home_score away_score outcome
Group 1 1930-07-13 France Mexico 4 1 H
Group 4 1930-07-13 Belgium United States 0 3 A

When was the most recent match from the data?

stage date home_team away_team home_score away_score outcome
Final 2018-07-15 France Croatia 4 2 H

Attendance Rate

How popular is the FIFA World Cup? How many attended? Which year had the highest amount of audience?

year host attendance games winner
1994 USA 3568567 52 Brazil
2014 Brazil 3441450 64 Germany
2006 Germany 3367000 64 Italy

Attendace Rate, pt2

Has USA won the FIFA World Cup? Or close to reaching the FIFA Cup?

year host winner second third fourth goals_scored teams games attendance
1930 Uruguay Uruguay Argentina USA Yugoslavia 70 13 18 434000

What Nations have won the FIFA World Cup?

winner year
Uruguay 1930
Italy 1934
Italy 1938
Uruguay 1950
West Germany 1954
Brazil 1958
Brazil 1962
England 1966
Brazil 1970
West Germany 1974
Argentina 1978
Italy 1982
Argentina 1986
West Germany 1990
Brazil 1994
France 1998
Brazil 2002
Italy 2006
Spain 2010
Germany 2014
France 2018

Which Nations have made it to Second Place?

second
Argentina
Czechoslovakia
Hungary
Brazil
Sweden
West Germany
Italy
Netherlands
Germany
France
Croatia

FIFA World Cup Winners count

Total Goals

Every match is exciting, especially when your team scores. Every one standing up screaming Gol, bumping to each other and even spealing our drinks to our neighbor. How many gols screams are there per game?

year home_team away_team home_score away_score Total_Gols
1930 France Mexico 4 1 5
1930 Belgium United States 0 3 3
1930 Brazil Yugoslavia 1 2 3
1930 Peru Romania 1 3 4
1930 Argentina France 1 0 1
1930 Chile Mexico 3 0 3
1930 Bolivia Yugoslavia 0 4 4
1930 Paraguay United States 0 3 3
1930 Uruguay Peru 1 0 1
1930 Argentina Mexico 6 3 9
1930 Chile France 1 0 1
1930 Belgium Paraguay 0 1 1
1930 Bolivia Brazil 0 4 4
1930 Uruguay Romania 4 0 4
1930 Argentina Chile 3 1 4

Ranked Most to Least amount of Total Gols in a match.

year home_team away_team Total_Gols
1954 Switzerland Austria 12
1938 Brazil Poland 11
1954 West Germany Hungary 11
1982 Hungary El Salvador 11
1958 France Paraguay 10
1930 Argentina Mexico 9
1954 Hungary South Korea 9
1954 West Germany Turkey 9
1958 France West Germany 9
1974 Yugoslavia Zaire 9
1934 Italy United States 8
1938 Cuba Sweden 8
1950 Bolivia Uruguay 8
1950 Brazil Sweden 8
1954 Belgium England 8
1962 Colombia Soviet Union 8
1966 North Korea Portugal 8
2002 Germany Saudi Arabia 8
2014 Brazil Germany 8
1930 Argentina United States 7

How many Gols per Quadrennial occur?

Which Team has scored the most goals?

team total_goals
Brazil 229
Argentina 137
West Germany 131
Italy 128
France 120
Spain 99
Germany 95
England 91
Hungary 87
Uruguay 87

Has any match end in extra time or penalties?

year home_team away_team win_conditions
1934 Austria France Austria won in AET
1934 Italy Czechoslovakia Italy won in AET
1938 Brazil Poland Brazil won in AET
1938 Czechoslovakia Netherlands Czechoslovakia won in AET
1938 Italy Norway Italy won in AET
1954 Hungary Uruguay Hungary won in AET
1958 Czechoslovakia Northern Ireland Northern Ireland won in AET
1966 England West Germany England won in AET
1970 England West Germany West Germany won in AET
1970 Soviet Union Uruguay Uruguay won in AET
1970 West Germany Italy Italy won in AET
1978 Argentina Netherlands Argentina won in AET
1982 West Germany France West Germany won in penalties (5 - 4)
1986 Soviet Union Belgium Belgium won in AET
1986 Brazil France France won in penalties (4 - 3)
1986 Mexico West Germany West Germany won in penalties (4 - 1)
1986 Spain Belgium Belgium won in penalties (5 - 4)
1986 France Belgium France won in AET
1990 Cameroon Colombia Cameroon won in AET
1990 Republic of Ireland Romania Republic of Ireland won in penalties (5 - 4)
1990 England Belgium England won in AET
1990 Spain Yugoslavia Yugoslavia won in AET
1990 Yugoslavia Argentina Argentina won in penalties (3 - 2)
1990 Cameroon England England won in AET
1990 Italy Argentina Argentina won in penalties (4 - 3)
1990 West Germany England West Germany won in penalties (4 - 3)
1994 Mexico Bulgaria Bulgaria won in penalties (3 - 1)
1994 Nigeria Italy Italy won in AET
1994 Romania Sweden Sweden won in penalties (5 - 4)
1994 Brazil Italy Brazil won in penalties (3 - 2)
1998 France Paraguay France won in AET
1998 Argentina England Argentina won in penalties (4 - 3)
1998 France Italy France won in penalties (4 - 3)
1998 Brazil Netherlands Brazil won in penalties (4 - 2)
2002 Spain Republic of Ireland Spain won in penalties (3 - 2)
2002 Sweden Senegal Senegal won in AET
2002 South Korea Italy South Korea won in AET
2002 South Korea Spain South Korea won in penalties (5 - 3)
2002 Senegal Turkey Turkey won in AET
2006 Argentina Mexico Argentina won in AET
2006 Switzerland Ukraine Ukraine won in penalties (3- 0)
2006 Germany Argentina Germany won in penalties (4 - 2)
2006 England Portugal Portugal won in penalties (3 - 1)
2006 Germany Italy Italy won in AET
2006 Italy France Italy won in penalties (5 - 3)
2010 United States Ghana Ghana won in AET
2010 Paraguay Japan Paraguay won in penalties (5 - 3)
2010 Uruguay Ghana Uruguay won in penalties (4 - 2)
2010 Netherlands Spain Spain won in AET
2014 Brazil Chile Brazil won in penalties (3 - 2)
2014 Costa Rica Greece Costa Rica won in penalties (5 - 3)
2014 Germany Algeria Germany won in AET
2014 Argentina Switzerland Argentina won in AET
2014 Belgium United States Belgium won in AET
2014 Netherlands Costa Rica Netherlands won in penalties (4 - 3)
2014 Netherlands Argentina Argentina won in penalties (4 - 2)
2014 Germany Argentina Germany won in AET
2018 Russia Spain Russia won in penalties (4 - 3)
2018 Croatia Denmark Croatia won in penalties (3- 2)
2018 Colombia England England won in penalties (4 -3)
2018 Russia Croatia Croatia won in penalties (4 - 3)
2018 Croatia England Croatia won in AET

How many matches played After Extra Time?

year stage win_conditions
1934 Round of 16 Austria won in AET
1934 Final Italy won in AET
1938 Round of 16 Brazil won in AET
1938 Round of 16 Czechoslovakia won in AET
1938 Round of 16 Italy won in AET
1954 Semifinals Hungary won in AET
1958 Group 1 Northern Ireland won in AET
1966 Final England won in AET
1970 Quarterfinals West Germany won in AET
1970 Quarterfinals Uruguay won in AET
1970 Semifinals Italy won in AET
1978 Final Argentina won in AET
1986 Round of 16 Belgium won in AET
1986 Third place France won in AET
1990 Round of 16 Cameroon won in AET
1990 Round of 16 England won in AET
1990 Round of 16 Yugoslavia won in AET
1990 Quarterfinals England won in AET
1994 Round of 16 Italy won in AET
1998 Round of 16 France won in AET
2002 Round of 16 Senegal won in AET
2002 Round of 16 South Korea won in AET
2002 Quarterfinals Turkey won in AET
2006 Round of 16 Argentina won in AET
2006 Semifinals Italy won in AET
2010 Round of 16 Ghana won in AET
2010 Final Spain won in AET
2014 Round of 16 Germany won in AET
2014 Round of 16 Argentina won in AET
2014 Round of 16 Belgium won in AET
2014 Final Germany won in AET
2018 Semifinals Croatia won in AET

How many matches made it to the Penalties stage?

year stage win_conditions
1982 Semifinals West Germany won in penalties (5 - 4)
1986 Quarterfinals France won in penalties (4 - 3)
1986 Quarterfinals West Germany won in penalties (4 - 1)
1986 Quarterfinals Belgium won in penalties (5 - 4)
1990 Round of 16 Republic of Ireland won in penalties (5 - 4)
1990 Quarterfinals Argentina won in penalties (3 - 2)
1990 Semifinals Argentina won in penalties (4 - 3)
1990 Semifinals West Germany won in penalties (4 - 3)
1994 Round of 16 Bulgaria won in penalties (3 - 1)
1994 Quarterfinals Sweden won in penalties (5 - 4)
1994 Final Brazil won in penalties (3 - 2)
1998 Round of 16 Argentina won in penalties (4 - 3)
1998 Quarterfinals France won in penalties (4 - 3)
1998 Semifinals Brazil won in penalties (4 - 2)
2002 Round of 16 Spain won in penalties (3 - 2)
2002 Quarterfinals South Korea won in penalties (5 - 3)
2006 Round of 16 Ukraine won in penalties (3- 0)
2006 Quarterfinals Germany won in penalties (4 - 2)
2006 Quarterfinals Portugal won in penalties (3 - 1)
2006 Final Italy won in penalties (5 - 3)
2010 Round of 16 Paraguay won in penalties (5 - 3)
2010 Quarterfinals Uruguay won in penalties (4 - 2)
2014 Round of 16 Brazil won in penalties (3 - 2)
2014 Round of 16 Costa Rica won in penalties (5 - 3)
2014 Quarterfinals Netherlands won in penalties (4 - 3)
2014 Semifinals Argentina won in penalties (4 - 2)
2018 Round of 16 Russia won in penalties (4 - 3)
2018 Round of 16 Croatia won in penalties (3- 2)
2018 Round of 16 England won in penalties (4 -3)
2018 Quarterfinals Croatia won in penalties (4 - 3)

All Together

Matches during the week

Summary

I was eager in learning what type of data was stored under the data frame. Having to displays the given information with graphs demonstrates a better understanding of Tournament.

Fans, Reporters, and Journalist try to predict who will take the title but their are so much data missing to consider the winning Nation. Who are the players? Is the weather under the same condition per Quadrennial? Who are the referees? And more..

Every Tournament is inpredictable. Is just what makes it exciting.